// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_ORDER_ITEM
// * CreateDate    : 2011/9/27 13:27:07
// * Creater       : CodeSmith
// * LastChangeDate: 2011/9/27 13:27:07
// * LastChanger   : 2011/9/27 13:27:07
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SalesOrderItemTable : TableInfo
    {
		public const string C_TableName = "SALES_ORDER_ITEM";
		
		public const string C_ORDER_ITEM_ID = "ORDER_ITEM_ID";
		public const string C_ORDER_ID = "ORDER_ID";
		public const string C_CONTACT_ID = "CONTACT_ID";
		public const string C_PRODUCT_ID = "PRODUCT_ID";
		public const string C_QTY = "QTY";
		public const string C_PRICE_NO_TAX = "PRICE_NO_TAX";
		public const string C_TAX_RATE = "TAX_RATE";
		public const string C_REMARK = "REMARK";
		public const string C_PRODUCT_SPEC_IN = "PRODUCT_SPEC_IN";
		public const string C_PRODUCT_SPEC_OUT = "PRODUCT_SPEC_OUT";
		public const string C_MATERIAL = "MATERIAL";
		public const string C_DIAMETER_OUT = "DIAMETER_OUT";
		public const string C_DIAMETER_IN = "DIAMETER_IN";
		public const string C_LENGTH = "LENGTH";
		public const string C_UNIT = "UNIT";
        public const string C_DELIVERY_DATE = "DELIVERY_DATE";
		public SalesOrderItemTable()
        {
            _tableName = "SALES_ORDER_ITEM";
        }
		
		protected static SalesOrderItemTable _current;
        public static SalesOrderItemTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SalesOrderItemTable();

            _current.Add(C_ORDER_ITEM_ID, new ColumnInfo(C_ORDER_ITEM_ID,"OrderItemId", true, typeof(string)));
            _current.Add(C_ORDER_ID, new ColumnInfo(C_ORDER_ID,"OrderId", false, typeof(string)));
            _current.Add(C_CONTACT_ID, new ColumnInfo(C_CONTACT_ID,"ContactId", false, typeof(string)));
            _current.Add(C_PRODUCT_ID, new ColumnInfo(C_PRODUCT_ID,"ProductId", false, typeof(string)));
            _current.Add(C_QTY, new ColumnInfo(C_QTY,"Qty", false, typeof(decimal)));
            _current.Add(C_PRICE_NO_TAX, new ColumnInfo(C_PRICE_NO_TAX,"PriceNoTax", false, typeof(decimal)));
            _current.Add(C_TAX_RATE, new ColumnInfo(C_TAX_RATE,"TaxRate", false, typeof(decimal)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_IN, new ColumnInfo(C_PRODUCT_SPEC_IN,"ProductSpecIn", false, typeof(string)));
            _current.Add(C_PRODUCT_SPEC_OUT, new ColumnInfo(C_PRODUCT_SPEC_OUT,"ProductSpecOut", false, typeof(string)));
            _current.Add(C_MATERIAL, new ColumnInfo(C_MATERIAL,"Material", false, typeof(string)));
            _current.Add(C_DIAMETER_OUT, new ColumnInfo(C_DIAMETER_OUT,"DiameterOut", false, typeof(decimal)));
            _current.Add(C_DIAMETER_IN, new ColumnInfo(C_DIAMETER_IN,"DiameterIn", false, typeof(decimal)));
            _current.Add(C_LENGTH, new ColumnInfo(C_LENGTH,"Length", false, typeof(decimal)));
            _current.Add(C_UNIT, new ColumnInfo(C_UNIT,"Unit", false, typeof(string)));
            _current.Add(C_DELIVERY_DATE, new ColumnInfo(C_DELIVERY_DATE, "DeliveryDate", false, typeof(DateTime)));
		}
		
		public ColumnInfo ORDER_ITEM_ID
        {
            get { return this[C_ORDER_ITEM_ID]; }
        }
		
		public ColumnInfo ORDER_ID
        {
            get { return this[C_ORDER_ID]; }
        }
		
		public ColumnInfo CONTACT_ID
        {
            get { return this[C_CONTACT_ID]; }
        }
		
		public ColumnInfo PRODUCT_ID
        {
            get { return this[C_PRODUCT_ID]; }
        }
		
		public ColumnInfo QTY
        {
            get { return this[C_QTY]; }
        }
		
		public ColumnInfo PRICE_NO_TAX
        {
            get { return this[C_PRICE_NO_TAX]; }
        }
		
		public ColumnInfo TAX_RATE
        {
            get { return this[C_TAX_RATE]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo PRODUCT_SPEC_IN
        {
            get { return this[C_PRODUCT_SPEC_IN]; }
        }
		
		public ColumnInfo PRODUCT_SPEC_OUT
        {
            get { return this[C_PRODUCT_SPEC_OUT]; }
        }
		
		public ColumnInfo MATERIAL
        {
            get { return this[C_MATERIAL]; }
        }
		
		public ColumnInfo DIAMETER_OUT
        {
            get { return this[C_DIAMETER_OUT]; }
        }
		
		public ColumnInfo DIAMETER_IN
        {
            get { return this[C_DIAMETER_IN]; }
        }
		
		public ColumnInfo LENGTH
        {
            get { return this[C_LENGTH]; }
        }
		
		public ColumnInfo UNIT
        {
            get { return this[C_UNIT]; }
        }

        public ColumnInfo DELIVERY_DATE
        {
            get { return this[C_DELIVERY_DATE]; }
        }
		
		
		
	}
}

